// ==========================================================================
// GFast自动生成dao internal操作代码。
// 生成日期：2024-11-11 17:42:22
// 生成路径: internal/app/system/dao/internal/schools.go
// 生成人：王中阳
// desc:学校
// company:云南奇讯科技有限公司
// ==========================================================================

package internal

import (
	"context"

	"github.com/gogf/gf/v2/database/gdb"
	"github.com/gogf/gf/v2/frame/g"
)

// SchoolsDao is the manager for logic model data accessing and custom defined data operations functions management.
type SchoolsDao struct {
	table   string         // Table is the underlying table name of the DAO.
	group   string         // Group is the database configuration group name of current DAO.
	columns SchoolsColumns // Columns is the short type for Columns, which contains all the column names of Table for convenient usage.
}

// SchoolsColumns defines and stores column names for table schools.
type SchoolsColumns struct {
	Id         string //
	Province   string // 省份
	City       string // 城市
	Department string // 所属部门
	Level      string // 等级
	Schoolname string // 学校名称
	Type       string // 类型
	Code       string // 编码
	Show       string // 是否显示 1是 0否
	Lat        string // 经度
	Lng        string // 纬度
	CreatedAt  string //
}

var schoolsColumns = SchoolsColumns{
	Id:         "id",
	Province:   "province",
	City:       "city",
	Department: "department",
	Level:      "level",
	Schoolname: "schoolname",
	Type:       "type",
	Code:       "code",
	Show:       "show",
	Lat:        "lat",
	Lng:        "lng",
	CreatedAt:  "created_at",
}

// NewSchoolsDao creates and returns a new DAO object for table data access.
func NewSchoolsDao() *SchoolsDao {
	return &SchoolsDao{
		group:   "default",
		table:   "schools",
		columns: schoolsColumns,
	}
}

// DB retrieves and returns the underlying raw database management object of current DAO.
func (dao *SchoolsDao) DB() gdb.DB {
	return g.DB(dao.group)
}

// Table returns the table name of current dao.
func (dao *SchoolsDao) Table() string {
	return dao.table
}

// Columns returns all column names of current dao.
func (dao *SchoolsDao) Columns() SchoolsColumns {
	return dao.columns
}

// Group returns the configuration group name of database of current dao.
func (dao *SchoolsDao) Group() string {
	return dao.group
}

// Ctx creates and returns the Model for current DAO, It automatically sets the context for current operation.
func (dao *SchoolsDao) Ctx(ctx context.Context) *gdb.Model {
	return dao.DB().Model(dao.table).Safe().Ctx(ctx)
}

// Transaction wraps the transaction logic using function f.
// It rollbacks the transaction and returns the error from function f if it returns non-nil error.
// It commits the transaction and returns nil if function f returns nil.
//
// Note that, you should not Commit or Rollback the transaction in function f
// as it is automatically handled by this function.
func (dao *SchoolsDao) Transaction(ctx context.Context, f func(ctx context.Context, tx gdb.TX) error) (err error) {
	return dao.Ctx(ctx).Transaction(ctx, f)
}
